Re: Low Budget Performance, Part 2 - Mailing list pgsql-performance

From eric soroos
Subject Re: Low Budget Performance, Part 2
Date
Msg-id 30918002.1173644217@[4.42.179.151]
Whole thread Raw
In response to Re: Low Budget Performance, Part 2  (Richard Huxton <richardh@archonet.com>)
List pgsql-performance
> > I'm suspect that the previous runs were colored by having the entire
> > dataset in memory as well as the update contention.
>
> A run of vmstat while the test is in progress might well show what's affecting
> performance here.

Unfortunately, vmstat on OSX is not what it is on Linux.

vm_stat on osx gives virtual memory stats, but not disk io or cpu load.
iostat looks promising, but is a noop.
Top takes 10 % of processor.

eric



pgsql-performance by date:

Previous
From: Justin Clift
Date:
Subject: Re: Low Budget Performance, Part 2
Next
From: eric soroos
Date:
Subject: Re: Low Budget Performance, Part 2